Skip to main content
TrustRadius
MySQL

MySQL

Overview

What is MySQL?

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

Read more
Recent Reviews

Reliable and easy to use database

9 out of 10
November 20, 2023
It is solving the problem of efficient processing of a decent amount of data sets. Before that, all data was stored in an Excel sheet, …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Product Demos

E-Commerce Website using PHP and MySQL || Project Demo || Part -1

YouTube

Small CRM Project using PHP and MySQL (Free Download)

YouTube

User Registration Form with PHP and MySQL Tutorial 5 - Add Form Validation + Final Demo

YouTube

MySQL database WinForms CRUD Demo. (CREATE,READ,SELECT,UPDATE,DELETE) | C#

YouTube

MySQL Enterprise Edition [Newer Version Available]

YouTube

C# MySQL database WinForms CRUD Demo. (CREATE,READ,SELECT,UPDATE,DELETE)

YouTube
Return to navigation

Product Details

What is MySQL?

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

MySQL Videos

What is MySQL?
MySQL is one of the most popular database software options for businesses of all sizes. The software is open source, and highly customizable, so users can set up an instance that meets their needs.
While MySQL is a specific product, NoSQL is a type of database that includes a number of available products. Whether a NoSQL (nonrelational database) product or using MySQL (relational database) is right for you greatly depends on the data you are storing, queries, and flexibility.

MySQL Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

Microsoft Access, Google Cloud SQL, and Amazon Redshift are common alternatives for MySQL.

Reviewers rate Usability highest, with a score of 10.

The most common users of MySQL are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(964)

Attribute Ratings

Reviews

(1-25 of 65)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
It is solving the problem of efficient processing of a decent amount of data sets. Before that, all data was stored in an Excel sheet, which was difficult to manage, and the configuration system froze during processing. However, with the advent of RDBMS, it solves a very critical problem for us.
  • It is extremely easy to use.
  • It offers host based verification and password encryption which makes it very secure
  • It assures 24/7 uptime which is great relief for us
  • It lacks container types and arrays
  • It is prone to DDos attacks that slows down and possibly crashes the database
  • It is not built to tackle complex queries and huge datasets
If you are looking for a database management system which is easy to use then MySQL should be the number one choice without a doubt, however, if you are looking a platform to handle large datasets and complex queries then you might have to give it a thought.
Score 5 out of 10
Vetted Review
Verified User
Incentivized
We use MySql to store our long time storage data and a backup place for our OpenSearch indexes so if any index is corrupted or delted we can easily use the backup from he db and also we use it as a single source of truth for all of our operations and data and stuff
  • Storing data for long term storage
  • More Intutuitve Worbench than orcale sql workbench
  • Easy to Learn for a new Comer
  • Community Support is excellent
  • Old Battle Test TEch not like som enew software
  • The workbench is old caould use some impovement
  • Need support for different type of indexing
From me as a long-term storage user perspective it's good, it's not good if you need lighting fast response time it's just not made for it u can use other NoSQL databases but for relational i think MySQL is the most newbie-friendly database in the market
Rao Tahir | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Due to its friendly user ineterface and extensilbility with upgraded new features, we as full stack developers perfer to user it for storing and reterving our data. The main problem that it has fixed for us will be its feature of supporting large databases. Also, due to the client and utiliy programs that Mysql offers it is one of the best choices for our business needs.
  • Data storage
  • Integration
  • Scalibility
  • Error Messages
  • Query Optimization
  • Version Errors
It has some great features for storing large sets of rows so it is well recommended for storing large chunks of data. As for the less suited, it may be a bit of a hassle while trying to optimise the queries for trying to achieve better performance of the retrieval of data.
Score 8 out of 10
Vetted Review
Verified User
We are a service-based company so we have multiple projects running simultaneously and many times the projects can be of different domains as well. We needed a system that could be used for multiple domains easily so that our teams do not have to learn a new technology every time they work on a new project and also be cost-effective. when choosing the DBMS system we opted for MySQL as it is lite weight, efficient, and open source. Thus reducing the cost as well as increasing our productivity.
  • We use MySQL in the development of our Client specific E-COmmerce website, as it is an efficient and easy-to-manage System with a lot of features.
  • Backup and restore functions are really good so if anything goes wrong on client-server it is easy to restore our data.
  • A major drawback of MySQL is it cannot be used on large database sizes and slows down in such cases.
MySQL is best when used for client-specific projects with medium size databases. Whereas if the data is going to be extensive Mysql is not as suited as compared to MSSQL or Postgre.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use MySQL as the backend database for vendor products that support MySQL. It is an open source product so it addresses licensing costs as compared to using MS SQL.
  • It's a very secure DB
  • Reduced TCO
  • High Performance
  • Doesn't support very large DBs efficiently
  • No stored procedures
For smaller database backends, this product works well. Our backend printer management software is using MySQL as its backend and we have not had any issues since it went live 2 years ago. It's also free so no licensing worries.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
My Organisation holds legacy infrastructure, and to make it compatible with other systems, we used MySQL as a barrier, and the solution worked well for us. Moreover, being open-source, it is more financially compatible and has many customized solutions in MySQL.
  • Barrier for legacy Infrastructure.
  • Open source.
  • Unlimited Customised solutions.
  • MySQL Cloud should be more reliable and better.
  • We should get some more ETL Featured syntaxes.
We do have an interaction between Linux and Windows systems. MySQL played a vital role in connecting across different platforms. MySQL Cannot support huge data and doesn't have many debugging features.
Rohit Goyal | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
I use Mysql in my organisation to save the data of our application and maintain historical data of our application and user data and logging data. Mysql is very compatible with all the frontend applications build in any languages, which helps us to have durability of the application data and also can perform many scheduled jobs in mysql
  • Atomicity
  • Durability
  • Consistency
  • Isolation
  • My Sql User interface
  • Message Queuing Technology
  • Generate SQL Scripts
Mysql is recommended when we have budget issues in our application and we need to spend less money in backend of the application as this is a open source tool and can give may functionalities, where as if our applications have need for scheduling jobs and scheduling tasks and creating queues mysql is less appropriate
John Ramírez | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used on one side of our organization, where the need for a strong and free database engine is mandatory. It covers all the needs we have related to efficiency and database handling, as many others paid engines, and we are happy with the performance and availability of the data stored on it. Due to customs restrictions, we choose MySQL as the most convenient engine, and we are very pleased with our choice.
  • Availabilty of the data
  • Complex queries
  • Data storage and maintenance
  • Optimization
  • Support
  • Connection witout plug-ins
It is perfectly suited for a company, that has a limited budget to pay for a database engine, and needs all of the capabilities of a paid service. Also needs complex data structures as well as connection with most of the data mining or business intelligence. Also great for open-source operating systems, because of their simplicity to install and maintain.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use MySQL Database multiple departments across the organization as an RDMS(relational database management system) for small-medium projects, easy to implement, cost-effective, easy to make changes, easy test, and supports millions of records. MySQL supports multiple database engines and we use mostly InnoDB to store the data, organize the data, and reporting purposes.
  • Multiple database engines.
  • Open source
  • Supports millions of records.
  • User interface to manage DB.
  • Data replica or auto sync between two servers.
MySQL is free to use under the GNU license so most of the open-source, non-profit organizations can use it for free, it is easy to adapt and implement, and most cost savings compare with other SQL providers in the market. It is most suitable for small to medium projects and not recommend for banking and enterprise projects.
Jose Manuel Ortega | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We use MySQL mainly as a database management system for small applications oriented to the management of resources of the different projects that store information related to the employees, either for the management of tasks or to allocate the hours that each employee registers in the project. We generally use it together with the PHP programming language and Apache Web Server using the LAMP distribution (Linux + Apache + MySQL + PHP).
  • Easy integration with development tools and environments, as well as connection with different programming languages
  • The support for handling transactions allows recovering from failures in operations and thus maintain data integrity.
  • Efficient use of resources at the memory and CPU level
  • Cross-platform support for different operating systems
  • Lack of documentation for a large percentage of MySQL utilities, for example the aspect of data replication for certain cases there is no documentation.
  • Some experience is required to configure and tune it to the project requirements.
  • Migration from standard SQL is sometimes not automatic and requires manual migration.
  • It is a suitable database for web applications where we have a large size of users. It is also easily scalable and provides good user management and access controls at the security level.
  • MySQL is a very fast database to read when using the non-transactional MyISAM engine, but it can cause integrity problems in high-concurrency environments when modifying. Thus, for applications with many parallel transactions and modifications, MySQL is probably not the best solution
Yaniv Vararu | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
MySQL is serving more than one department in our organization. In the R&D department, it's being used as part of our software development. Other departments such as product, customer success, support, business development, and more are using it for managing the customers, for getting analytics, for creating reports and dashboards, and acting by this data.
  • Since MySQL is open source, it is free to use under the GNU license
  • Before any update to data, it pops up a summary for approval, which lowers the risk of making a mistake
  • Performance is great if you need a relatively small DB
  • Compatible with many operating systems and integrates with many development tools
  • If you need a big/huge RDBMS, MySQL is probably not for you (performance-wise)
  • Complex joins/transaction handling causes temp hangs and performance issues--this can be improved
  • Fine tuning is not that easy--you'll probably need an expert (in-house or outsourced) for it
MySQL is best suited for us in managing our customers' definitions, accounts' structures, configurations, etc.--anything that is being set up once and updated only once in a while (and grown at low scales). The data of our customers' actions in the system is not saved in the MySQL DB since this changes in real time every second and this type of DB is less suited for so much data and such frequent changes.
April 12, 2021

MySQL works well

Score 9 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used as our relational data store for information in support of our software platform - software as a service for internal communications and employee experience. It is used across the entire product offering for frequently accessed and transactional data with multiple instances including master, failover, and read replicas.
  • Very quick to get up and running - easy to use.
  • It can run on very small virtual machines
  • It performs well and is flexible
  • MySQL always consumes all the memory available on a box and sometimes releasing resources can be an issue.
  • There are certain commands that can get you into trouble and create corruption which is not easily remedied.
  • Transaction handling is not the most efficient and larger databases can take some performance hits.
MySQL is well suited for anyone who needs a relational database and is working within a budget. Since it is open source, it is free to use and has most of the features of something like Oracle or MS SQL Server. MySQL can struggle a little with larger applications and storing the data cache in RAM requires fairly robust machines.
Manav Goel | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used by the whole company. This is a very useful structured database managing tool which helps us in our day-to-day data mining and creating excel with this huge data. The best part of it is if we accidentally make any wrong inputs while capturing any of the data details in our day-to-day activity it can be very easily fixed for a long list of sheets in a single go with a set of queries. MySQL provides the best way to interact with the SQL database. It offers the best available security toward SQL database and maintenance also it takes care of large databases to be optimised and responsive to every action.
  • Data security- MySQL provides a very high-level of security.
  • High performance-MySQL provides very high performance in terms of data mining . A huge amount of data can be easily extracted in couple of seconds.
  • Easy management - This is very easy to manage and easy to demo to employees so they can get hands on quicly.
  • I would say it has few stability issues. It crashed for me, but this is very rare.
  • Another thing is definitely a user cannot start using this right away without any training.
MySQL is best suited in extracting and storing data in different databases and I feel this is a very easy-to-use tool.
Score 9 out of 10
Vetted Review
Verified User
MySQL is a great Open Source Relational Database Management System(RDBMS). It has a lot of features. It is very stable. It provides an easy to use GUI with options for DDL, DML and DCL operations. One can easily create/alter tables, views, procedures, triggers, functions, indexes and much more. Writing queries, sub queries and joins are easily possible with MySQL.
  • MySQL is compatible to run on many OS like Windows, Unix, Linux.
  • MySQL allows transactions to be rolled back, commit, and crash recovery.
  • MySQL is very secure as it keeps passwords encrypted
  • MySQL does not support a very large database size as efficiently as other databases do.
  • Transaction handling is not very efficient.
  • SQL check constraint is not supported by MySQL.
MySQL will be most suited when the database size is not going to be very large. MySQL is a very fast, reliable, secure and stable database. When it comes to commercials, MySQL is open-source and free software under the GNU license. It is free to use, we can download it from MySQL official website without any cost. MySQL provides high performance when compared to other databases.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used within the whole organization as one of the two primary RDMBS. It is the underlying RDBMS database for the internal and external company records, hosted on Oracle PaaS.
  • Best in breed in open-source RDBMS databases.
  • Portability with our secondary database Oracle Database without much scheme changes.
  • Scales well with IaaS.
  • Some restrictions on the table sizes and schemes (unlike IBM DB2, Oracle DB, etc).
  • Issues with some of the SQL operations ( merge join, hash join, etc) that degrades the overall performance of the queries.
  • Licensing from Oracle for MySQL use can be improved.
MySQL is best suited for environments where the datasets are not large and there are no critical performance constraints. It is less appropriate for extremely large relational datasets and/or where performance guarantees are needed in the applications.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used in my company to store transactional data of modern applications that have been developed with an SOA architecture oriented to services and microservices, since these require multiple databases that are stable, light and have high availability.
  • Excellent response times when consulting data
  • Easy to learn, use and manage
  • It is necessary to invest time and effort to implement additional functionalities that are required in business environments, such as data replication.
  • When acquired by Oracle, its innovation speed has decreased, which opens the way for other competitors.
The strengths of MySQL can be exploited when it is necessary to store relational data in small, medium-sized applications or those in which its architecture is service oriented. I see it less appropriate for it to be used in monolithic applications with complex database structures.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used at the organization level but mainly for web applications in the organization.
  • Very good for basic to enterprise-level needs.
  • Cost-effective
  • MySQL has some limitation with complex data types.
  • Limitations with common table expressions.
MySQL is the best and simple open source Relational Database Management System that provides ease of use. MySQL supports many interfaces and programming languages, and also it is easier to learn for a newbie.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
MySQL is being used for many software in my company development for specific departments and software for all employees across the organization like human resources forms, Content Management Systems for website and intranet, health forms, satisfaction survey software.
  • Easy to learn.
  • Easy to use and manage.
  • Easy to backup and restore.
  • Have a community version open source.
  • More documentation.
  • Efficiently manage big amount of data.
I recommend MySQL for small and medium companies. MySQL is a strong database and you can store your company data, and connect your software easily.
November 04, 2019

MySQL - Old User's Review

Holman Cárdenas, M.Eng, TOGAF®, ITIL® | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I have used MySQL across different companies, mainly as a DB for web pages (along with Apache and PHP) and web-based applications (internal and external). It provides a fast, reliable and efficient DB solution.
  • Very fast and reliable DB
  • Innodb tables are a huge improvement
  • Works very good with the open-source ecosystem, even though it was adquired by Oracle
  • InnoDB tables performance could be improved
  • Tuning is a little bit complex
  • InnoDB tables do not support full-text searches
MySQL is well suited when you are using web pages or web applications in an open-source ecosystem (i.e. Php, Apache) and/or CMS as Joomla, Drupal, WordPress, etc. Not recommended for core or critical-mission applications (it stills need a higher maturity level).
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Yes, it is being used by a department to retrieve information as per customer needs.
  • Excellent market penetration.
  • Easy to get started.
  • Open-source license for most users.
  • I have only two years experience so I have not found any improvement but everything so far I used was good to me.
As per my experience, MySQL is best to use as an inventory management system, where based on different conditions, users need to retrieve data for analysis. Also, it is easy to learn so, a user can quickly become comfortable with it.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used in the whole organization, for variety of engineering and business purposes. Examples of uses:
  • DevOps pipelines data
  • Software artifact data and metadata
  • Test results
  • Validation results
  • Users and their associated data
  • Extracts from Big Data systems
MySQL is a data store many users are familiar with, and that makes for easy adoption. The infrastructure teams have experience in running it reliably.
  • Popular
  • Improving capabilities over time
  • Widespread knowledge
  • Reactive APIs
  • NoSQL support
  • Graph data models
  • Conventional relational data model
  • Small and medium data sets work well
  • For large data sets consider enhancements like Vitesse
  • The new JSON document support is an excellent addition. This enables us to eliminate some NoSQL document stores (for example, MongoDB or CouchDB, Couchbase) and instead use only one database for various uses.
  • The development and support team are familiar with RDBMS.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
MySQL is being used by our core team to develop and test out our prototype applications. It is lightweight, easy to use, and offers plugins for almost all of the widely used programming languages. Thanks to MySQL, spinning up a database to back prototype applications is a quick process. The rest of my organization is using Oracle Database 12c.
  • It is designed for Web, Cloud and Big Data. It provides high availability, self-healing and data integrity, provisioning, monitoring and resource management, developer agility, and security.
  • There is complete workflow control, allowing users to tweak all aspects of MySQL.
  • There is a variety of user interfaces that can be implemented, lowering the burden on programmers.
  • Incremental backups take more time and hassle to configure compared to other databases.
  • There is no built-in support for XML and OLAP which hurts business intelligence related analytics.
  • MySQL has gotten farther away from the open-source mentality. MySQL has proprietary and closed-source modules.
It is well-suited for prototyping applications and applications that are not Enterprise scale. Many big names such as Red Hat Enterprise Linux, Fedora, Slackware Linux, and openSUSE, have all switched from MySQL to MariaDB. Hence, for solutions that have longevity concerns in regards to the technologies it is using, MySQL may not be the best option out there.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I am a Research Engineer in VizioChron, Inc. I have to use MySQL often. First, it is used by consumers that I work with. Second I have to do some experimental designs and implementations with the use of it. As it is open source it is easy to use it in common web projects e.g. LAMP.
  • Database works well with MyPHP
  • There is design that uses the database with Wordpress
  • It is easily integrated with web engines, e.g. Apache
  • Some migration SQL<>MySQL would be in demand
  • Maybe some features that MongoDB has could enhance MySQL
  • Maybe more GUI for simplicity of operations under a Linux environment
It is a well-suited solution for a web server and web hosting, in my opinion. Moreover, as it is easy to integrate it with web engines it is a good fit for websites that utilize registration feature and membership areas. MySQL has a robust support of command line commands execution and could be operated completely from the terminal.
Score 8 out of 10
Vetted Review
Verified User
We used MySQL to store website data in database tables and to run queries to show and save data in the database. It is used by the whole organization where required to improve performance.
  • Consecutive Queries run simultaneously very fast.
  • MySQL documentation is very easily searchable online and easy to understand.
  • We can use it easily on the remote system as well.
  • It could improve its large database size.
  • It could provide its role and commit functions, etc.
  • There are a few stability issues.
1. Its implementation of an SQL database is very well suited for small to medium web pages. 2. The database is free and open source, with a commercial license available. 3. It must be easily manageable with a huge database.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
MySQL is being used to log datasets from a series of electro-mechanical devices (due to NDA, I cannot discuss the specifics). These devices are mechanical in nature, with sensors monitoring properties of the devices. In this particular context, I am looking for failure points and building risk models around those points. However, I have looked at multiple databases for this particular project, and without a doubt, MySql is my favorite as it's simple to set up, and works seamlessly with a LAMP (Linux, Apache, MySql, Php) installation), which really is the selling point here.
  • Speed: returning results from broad queries are a breeze.
  • High Availability: some of the central themes in MySQL are open source. As a result, no "Patch Tuesdays."
  • TCO: The fact that MySQL is an open source project, coupled with strong support and a low failure rate, make its overall total cost of ownership very low and extremely easy to introduce into a lab or research project.
  • Language support: I know this is a little far fetched, but moving from one RDBMS to another is, at times, jarring. I'd like to see some compatibility with other household names (i.e. SQL Server).
  • Along the same line, relaxing the syntax constraints would be nice (i.e. yes/no on the semicolon. Make it optional).
  • MySql needs to develop its features so that it maintains compatibility with more robust and common RDBMS (i.e. Oracle/SQL SERVER).
  • Oracle: Oracle should really think about this: is MySQL so different from their other flagship products that they feel they need to maintain it? Why not roll it up into a single, powerful tech?
By far, the most common reason to use MySQL (mine included, initially) is that you cannot have a LAMP stack without MySQL. Every shred of documentation (almost) on the web implements MySQL as apart of a LAMP stack, and I feel this is truly where MySQL shines. It's packaged, and it performs very similarly to other technologies, and as a result, creates a niche market for itself. Perhaps the future of MySQL will be something like a front-end to other DBs, or perhaps they will pivot from relational to something like document or object. Just a thought.
Return to navigation